Microsoft Excel Q/a Practice Questions Answers Test With Solutions & More Shortcuts

Question : 1

In Excel circular reference is

a) Geometric modeling tool

b) A cell that points to a drawing object

c) A formula that either directly or indirectly depends on itself

d) Always erroneous

Question : 2

The short cut key Ctrl +R is used in Excel to

a) Right align the content of cell

b) Remove the cell contents of selected cells

c) Fill the selection with active t cells to the right

d) All of above

e) None of these

Question : 3

The cell reference from a range of cells that starts in cell Bl and goes over to column G and down to row lOis......

a) DB1-G10

b) B1.G10

c) B1;G10

d) B1:G10

e) None of these

Question : 4

The box on the chart that contains the name of each Individual record Is called the__.

a) cell

b) title

c) axis

d) legend

e) None of these

Question : 5

Which of the following is invalid regarding the Protection in Excel?

a) Protect Sheet

b) Protect Workbook

c) Protect Workspace

d) All of above are valid

e) None of these